USE [GESTION2]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0008_DROPS_TABLES]    Script Date: 11/22/2011 16:28:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WASP_D0008_DROPS_TABLES]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WASP_D0008_DROPS_TABLES]
GO

USE [GESTION2]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0008_DROPS_TABLES]    Script Date: 11/22/2011 16:28:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<JJ>
-- Create date: <01/08/2011>
-- Description:	<limpia tablas>
-- =============================================
CREATE PROCEDURE [dbo].[WASP_D0008_DROPS_TABLES]

AS
BEGIN
if exists (select * from dbo.sysobjects where id = object_id(N'[as_cuotas_spt_temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [as_cuotas_spt_temp]

if exists (select * from dbo.sysobjects where id = object_id(N'[spt_temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [spt_temp]

if exists (select * from dbo.sysobjects where id = object_id(N'[seguro_proteccion_temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [seguro_proteccion_temp]

END

GO

